StudentRevenueDetail

EntityType | Independent
Logical Entity Name | StudentRevenueDetail
Default Table Name | SaRevenueDetail
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentRevenueDetail Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentRevenueDetailId |  | INTEGER | NO |
StudentRevenueSummaryId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
BillingTransactionCode |  | CHAR(8) | NO |
AcademicYearSequence |  | NUMERIC(3, 0) | NO |
TermId |  | INTEGER | YES |
Reference |  | CHAR(8) | YES |
TransactionDate |  | DATETIME | NO |
PostDate |  | DATETIME | YES |
Type |  | CHAR(1) | NO |
Source |  | CHAR(1) | NO |
Amount |  | MONEY(19, 4) | NO |
UnitsEarned |  | NUMERIC(7, 2) | NO |
TotalUnits |  | NUMERIC(7, 2) | NO |
Status |  | CHAR(1) | NO |
BatchNumber |  | CHAR(8) | YES |
PostAccount |  | NVARCHAR(100) | NO |
OffsetAccount |  | NVARCHAR(100) | NO |
GLPost |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
StudentAccountTransactionId |  | INTEGER | YES |
FutureRevenue |  | MONEY(19, 4) | NO |
FutureCharges |  | MONEY(19, 4) | NO |
SchoolStatusId |  | INTEGER | NO |
StudentRevenueSummaryChildTermId |  | INTEGER | YES |
ChildTermId |  | INTEGER | YES |
IsEarnedOnChildTerm |  | BIT | NO |
ExceptionCode |  | VARCHAR(50) | YES |
PreviousEarnedPercentageBatch |  | VARCHAR(8) | YES |
CarryOverAmount |  | NUMERIC(7, 2) | YES |
IsGlStatusFlag |  | BIT | NO |

StudentRevenueDetail Keys

Key Name | Key Type | Keys
SaRevenueDetail_ChildAdtermID_N_N_IDX | Inversion Entry | ChildTermId
SaRevenueDetail_Ref_Status_N_N_IDX | Inversion Entry | Reference, Status
SaRevenueDetail_Ref_N_N_IDX | Inversion Entry | Reference
SaRevenueDetail_BatchNo_N_N_IDX | Inversion Entry | BatchNumber
SaRevenueDetail_SaEnrollRevenueChildtermID_N_N_IDX | Inversion Entry | StudentRevenueSummaryChildTermId
ix_SaRevenueDetail_Source_StatusTransDate_includes | Inversion Entry | Source, Status, TransactionDate
SaRevenueDetail_AdTermID_N_N_IDX | Inversion Entry | TermId
SaRevenueDetail_TransDate_N_N_IDX | Inversion Entry | TransactionDate
SaRevenueDetail_SaBillCode_N_N_IDX | Inversion Entry | BillingTransactionCode
SaRevenueDetail_SaRevenueDetailID_U_C_IDX | PrimaryKey | StudentRevenueDetailId
SaRevenueDetail_SaEnrollRevenueID_Status_N_N_IDX | Inversion Entry | Status
SaRevenueDetail_TransDate_SaEnrollRevenueID_Type_Source_Amount_FutureCharges_TotalUnits_SySchoolStatusID_SaRevenueDetailID_U_N_ | Alternate Key | TransactionDate, Type, Source, Amount, FutureCharges, TotalUnits, SchoolStatusId, StudentRevenueDetailId

StudentRevenueDetail Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | ChildTermId | NO
StudentRevenueSummaryChildTerm | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentRevenueSummaryChildTermId | NO
StudentAccountTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAccountTransactionId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
StudentRevenueSummary | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentRevenueSummaryId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
GeneralLedgerReleaseBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentRevenueDetail Check Constraints

Check Constraint Name | CheckConstraint

StudentRevenueDetail Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentRevenueDetail | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaRevenueDetail | NO |  |  |

StudentRevenueDetail Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Revenue_GL_BankDeposit
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

StudentRevenueDetail Data Movement Rules

Name | Type | Rule Text/Value